
package com.feib.ebilling.job.dao;

import org.springframework.stereotype.Repository;


/**
 * @title (#)BankingFeedbackCheckDao.java<br>
 * @description <br>
 * @author Jimmy Liu<br>
 * @version 1.0.0 2010/11/25
 * @copyright Far Eastern International Bank Copyright (c) 2010<br>
 * @2010/12/11 create by Jimmy Liu<br>
 */
@Repository("bankingFeedbackCheckDao")
public class BankingFeedbackCheckDao extends BaseDao  {

    /**
     * @param fileNamePrefix
     * @return
     */
    public long countByFbfileName(String fileNamePrefix) {
        StringBuffer sql = new StringBuffer();
        sql.append("select count(*) from FEEDBACK_LOG where FBFILENAME like ? and FEEDBACK_TYPE = 1 and len(FBFILENAME) = 32");
        return this.getJdbcTemplate().queryForInt(sql.toString(), fileNamePrefix+"%");
    }

}
